package cn.tedu.jdbc;

import java.sql.*;
import java.util.Scanner;

public class JDBCReg {
    public static void main(String[] args) {
        try(Connection connection=DBUtil.getConnection();){
            Scanner scanner=new Scanner(System.in);
            System.out.println("用户名：");
            String username=scanner.nextLine();
            System.out.println("密码");
            String password =scanner.nextLine();
            System.out.println("昵称");
            String nickname=scanner.nextLine();
            System.out.println("年龄");
            Integer age=scanner.nextInt();

            String sql1="SELECT id FROM userinfo WHERE username=?";
            PreparedStatement ps1 = connection.prepareStatement(sql1);
            ps1.setString(1,username);
            ResultSet rs1 = ps1.executeQuery();
            if(rs1.next()) {
                System.out.println("该用户名被占用");
            }else{
                String sql2 ="INSERT INTO userinfo (username,password,nickname,age) VALUES (?,?,?,?)";
                PreparedStatement ps2=connection.prepareStatement(sql2);
                ps2.setString(1,username);
                ps2.setString(2,password);
                ps2.setString(3,nickname);
                ps2.setInt(4,age);
                int i=ps2.executeUpdate();
                if (i>0){
                    System.out.println("恭喜你，注册成功");
                }else{
                    System.out.println("系统繁忙，请稍候再试");
                }
            }
        }catch (SQLException e){
            throw new RuntimeException(e);
        }
    }
}
